package com.huanying.framework.user;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.swing.text.html.FormSubmitEvent.MethodType;

import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import com.aliyuncs.DefaultAcsClient;
import com.aliyuncs.IAcsClient;
import com.aliyuncs.dysmsapi.model.v20170525.SendSmsRequest;
import com.aliyuncs.dysmsapi.model.v20170525.SendSmsResponse;
import com.aliyuncs.profile.DefaultProfile;
import com.aliyuncs.profile.IClientProfile;
import com.huanying.framework.BaseDao;
import com.huanying.framework.PageBean;
import com.huanying.framework.utils.Date;
import com.huanying.framework.utils.MemCachedManager;



@Service
public class UserServiceImpl implements UserService {
	
	@Autowired
	private BaseDao dao;

	@Override
	public void add(User user) throws Exception {
		dao.save(user);
	}

	@Override
	public void update(User user) throws Exception {
		dao.update(user);
	}

	@Override
	public void delete(User user) throws Exception {
		dao.delete(user);
	}
	
	@Override
	public void addUser_Label(User_Label user_label) throws Exception {
		dao.save(user_label);
	}


	@Override
	public User getbyId(int id) throws Exception {
		
		return (User) dao.load(User.class, id);
	}
   
	@Override
	public User getbyPhone(String phone) throws Exception {
		User user=new User();
		String hql = new String("from User u where u.status=1 and u.phone like ?");
		List<Object> params = new ArrayList<Object>();
		params.add("%"+phone+"%");
		user=(User) dao.exculeHqlGetOjbectByParams(hql, params);	
		return user;
	}
	/*@Override
	public User getbyNameIdCard(String name,String id_card) throws Exception {
		User user=new User();
		String hql = new String("from User u where  u.staus=1 and u.name like ? and u.id_card like ?");
		List<Object> params = new ArrayList<Object>();
		params.add("%"+name+"%");
		params.add("%"+id_card+"%");
		user=(User) dao.exculeHqlGetOjbectByParams(hql, params);	
		return user;
	}*/
	/*@Override
	public User getbyIdCard(String id_card) throws Exception {
		User user=new User();
		String hql = new String("from User u where u.status= 1 and u.id_card like ? ");
		List<Object> params = new ArrayList<Object>();
		params.add("%"+id_card+"%");
		user=(User) dao.exculeHqlGetOjbectByParams(hql, params);	
		return user;
	}*/
	
	@Override
	public PageBean searchUsers(Map<String, String> map, int pageSize, int page) throws Exception {
		// TODO Auto-generated method stub
		StringBuilder hql = new StringBuilder("from User as u where u.status=1");
		List<Object> param = new ArrayList<Object>();
		if (map.get("name") != null && !("").equals(map.get("name"))) {
			hql.append(" and u.name like ?");
			param.add("%" + map.get("name") + "%");
		}
		if (map.get("sex") != null && !("").equals(map.get("sex"))) {
			hql.append(" and u.sex like ?");
			param.add("%" + map.get("sex") + "%");
		}
		if (map.get("phone") != null &&  !("").equals(map.get("phone"))) {
			hql.append(" and u.phone like ?");
			param.add("%" + map.get("phone") + "%");
		}
		if (map.get("address_home") != null && !("").equals(map.get("address_home"))) {
			hql.append(" and u.address_home like ?");
			param.add("%" + map.get("address_home") + "%");
		}
		if (map.get("id_card") != null && !("").equals(map.get("id_card"))) {
			hql.append(" and u.id_card like ?");
			param.add("%" + map.get("id_card") + "%");
		}
		if (map.get("money") != null && !("").equals(map.get("money"))) {
			Double money = Double.valueOf(map.get("money"));
			hql.append(" and u.money = ?");
			param.add(money);
		}
		if (map.get("beans") != null && !("").equals(map.get("beans"))) {
			Integer beans = Integer.valueOf(map.get("beans"));
			hql.append(" and u.beans = ?");
			param.add(beans);
		}
		if (!("").equals(map.get("create_time")) && map.get("create_time") != null) {
			hql.append(" and DATE_FORMAT(u.create_time,'%Y-%m-%d')=?");
			param.add(map.get("create_time"));
		}
		int allRow = dao.queryAllRowCount(hql.toString(), param);
		int totalPage = PageBean.countTotalPage(pageSize, allRow);
		final int offset = PageBean.countOffset(pageSize, page);
	    final int currentPage = PageBean.countCurrentPage(page);
	    List<Object> list = dao.queryForPageAndParams(hql.toString(), param, offset, pageSize);
	    
	    //把分页信息保存到Bean中
        PageBean pageBean = new PageBean();
        pageBean.setPageSize(pageSize);    
        pageBean.setCurrentPage(currentPage);
        pageBean.setAllRow(allRow);
        pageBean.setTotalPage(totalPage);
        pageBean.setList(list);
        pageBean.init();
		
		return pageBean;
	}
	
	@Override
	public PageBean searchUsersAuthenticPer(Map<String, String> map, int pageSize, int page) throws Exception {
		// TODO Auto-generated method stub
		StringBuilder hql = new StringBuilder("from User as u where u.status=1");
		List<Object> param = new ArrayList<Object>();
		if (map.get("name") != null && !("").equals(map.get("name"))) {
			hql.append(" and u.name like ?");
			param.add("%"+map.get("name")+"%");
		}
		hql.append(" and u.user_authenticPer=2");
		int allRow = dao.queryAllRowCount(hql.toString(), param);
		int totalPage = PageBean.countTotalPage(pageSize, allRow);
		final int offset = PageBean.countOffset(pageSize, page);
	    final int currentPage = PageBean.countCurrentPage(page);
	    List<Object> list = dao.queryForPageAndParams(hql.toString(), param, offset, pageSize);
	    
	    //把分页信息保存到Bean中
        PageBean pageBean = new PageBean();
        pageBean.setPageSize(pageSize);    
        pageBean.setCurrentPage(currentPage);
        pageBean.setAllRow(allRow);
        pageBean.setTotalPage(totalPage);
        pageBean.setList(list);
        pageBean.init();
		
		return pageBean;
	}
	
	@Override
	public PageBean searchUsersAuthenticCom(Map<String, String> map, int pageSize, int page) throws Exception {
		// TODO Auto-generated method stub
		StringBuilder hql = new StringBuilder("from User as u where u.status=1");
		List<Object> param = new ArrayList<Object>();
		if (map.get("name") != null && !("").equals(map.get("name"))) {
			hql.append(" and u.name like ?");
			param.add("%"+map.get("name")+"%");
		}
		hql.append(" and u.user_authenticCom=2");
		int allRow = dao.queryAllRowCount(hql.toString(), param);
		int totalPage = PageBean.countTotalPage(pageSize, allRow);
		final int offset = PageBean.countOffset(pageSize, page);
	    final int currentPage = PageBean.countCurrentPage(page);
	    List<Object> list = dao.queryForPageAndParams(hql.toString(), param, offset, pageSize);
	    
	    //把分页信息保存到Bean中
        PageBean pageBean = new PageBean();
        pageBean.setPageSize(pageSize);    
        pageBean.setCurrentPage(currentPage);
        pageBean.setAllRow(allRow);
        pageBean.setTotalPage(totalPage);
        pageBean.setList(list);
        pageBean.init();
		
		return pageBean;
	}
	/*//豆交易
	@Override
	public void beanRecord(int user_id,int beans) throws Exception{//消费用户ID，交易豆
		Trade_Bean trade_bean = new Trade_Bean();
		User user= (User) dao.load(User.class, user_id);
		trade_bean.setUser_id(user_id);
		trade_bean.setBeans(beans);
		dao.save(trade_bean);//保存豆交易记录
		user.setBeans(user.getBeans()+beans);
		dao.update(user);//更新收入方用户的现有金额
	}*/
	
	/*//发送短信接口
	@Override
	public void sendSms(String phone,String TemplateCode,String RequestId,String code,String Message,String BizId)throws Exception{
		//设置超时时间-可自行调整
		System.setProperty("sun.net.client.defaultConnectTimeout", "10000");
		System.setProperty("sun.net.client.defaultReadTimeout", "10000");
		//初始化ascClient需要的几个参数
		final String product = "Dysmsapi";//短信API产品名称（短信产品名固定，无需修改）
		final String domain = "dysmsapi.aliyuncs.com";//短信API产品域名（接口地址固定，无需修改）
		//替换成你的AK
		final String accessKeyId = "LTAIKEpLP92keMk1";//你的accessKeyId,参考本文档步骤2
		final String accessKeySecret = "K0YCdPcuj3ub9dHUT2SGKpz9fM1Qxz";//你的accessKeySecret，参考本文档步骤2
		//初始化ascClient,暂时不支持多region（请勿修改）
		IClientProfile profile = DefaultProfile.getProfile("cn-hangzhou", accessKeyId,
		accessKeySecret);
		DefaultProfile.addEndpoint("cn-hangzhou", "cn-hangzhou", product, domain);
		IAcsClient acsClient = new DefaultAcsClient(profile);
		 //组装请求对象
		 SendSmsRequest request = new SendSmsRequest();
		 //使用post提交
		 //--request.setMethod(MethodType.POST);
		 //必填:待发送手机号。支持以逗号分隔的形式进行批量调用，批量上限为1000个手机号码,批量调用相对于单条调用及时性稍有延迟,验证码类型的短信推荐使用单条调用的方式
		 request.setPhoneNumbers(phone);
		 //必填:短信签名-可在短信控制台中找到
		 request.setSignName("阿里云短信测试专用");
		 //必填:短信模板-可在短信控制台中找到
		 request.setTemplateCode(TemplateCode);
		 //可选:模板中的变量替换JSON串,如模板内容为"亲爱的${name},您的验证码为${code}"时,此处的值为
		 //友情提示:如果JSON中需要带换行符,请参照标准的JSON协议对换行符的要求,比如短信内容中包含\r\n的情况在JSON中需要表示成\\r\\n,否则会导致JSON在服务端解析失败
		 request.setTemplateParam("{\"name\":\"Tom\", \"code\":\"123\"}");
		 //可选-上行短信扩展码(扩展码字段控制在7位或以下，无特殊需求用户请忽略此字段)
		 //request.setSmsUpExtendCode("90997");
		 //可选:outId为提供给业务方扩展字段,最终在短信回执消息中将此值带回给调用者
		 request.setOutId("yourOutId");
		//请求失败这里会抛ClientException异常
		SendSmsResponse sendSmsResponse = acsClient.getAcsResponse(request);
		if(sendSmsResponse.getCode() != null && sendSmsResponse.getCode().equals("OK")) {
		//请求成功
		//
		}
	}*/
/*	//存储发送的验证码
	public void addSmsCode(String phone,String code)throws Exception{
		IdentityCode identityCode= new IdentityCode();
		identityCode.setPhone(phone);
		identityCode.setCode(code);
		identityCode.setCreate_time(new Date());
		dao.save(identityCode);
	}
	//读出最新的一条验证码
	public IdentityCode getSmsCode(String phone)throws Exception{
		IdentityCode identityCode=new IdentityCode();
		String hql = new String("from IdentityCode i where i.status=1 and i.phone = ? and create_time=(SELECT MAX(create_time) FROM i) ");
		List<Object> params = new ArrayList<Object>();
		params.add(phone);
		identityCode=(IdentityCode) dao.exculeHqlGetOjbectByParams(hql, params);	
		return identityCode;
	}*/
	public void addCache(User user) throws Exception{
		MemCachedManager cache = MemCachedManager.getInstance();
		String fixed="user";
		cache.set(fixed+Integer.toString(user.getId()), user);
	}
	public User queryCache(String id) throws Exception{
		MemCachedManager cache = MemCachedManager.getInstance();
		String fixed="user";
		User userNew=new User();
		return userNew=(User) cache.get(fixed+id);
	}
	public void delCache(String id) throws Exception{
		MemCachedManager cache = MemCachedManager.getInstance();
		String fixed="user";
		cache.remove(fixed+id);
	}
	
}

